Introduction

COVID-19 has altered the world immeasurably. Schools and many workforces have been shift to become digitized and travel has been restricted. Mask use has been mandated by the government in many areas in the United States. With no end in sight of coronavirus cases dissipating, our group stems to give a visual presentation of COVID-19 incidence rates, as well as explore the correlation between COVID-19 and population densities, the U.S markets, and the percentage of mask usage by the top counties in the country.


Summary

The datasets we analyzed were taken from John Hopkins and Yahoo Finance. After combining these datasets, our data had 154 observations
and 40 columns.

The coronavirus has reached 5,044,864 cases and 162,938 deaths since it’s inception in the United States. The worst day of COVID-19 had 4928 deaths in a single day. The most cases in a single day was 76,930 cases.

Since the first COVID-19 case in the U.S, the DOW JONES index has reached a low of 18,591.93 and a high of 29,551.42. The S&P 500 has reached a high of 3,386.15 and a low of 2,237.40.

The highest positive rate in a single day was 0.211 and the lowest tests per cases in a single day had reached 4.734.


Monthly COVID & Market data in the U.S

This table shows a timeseries of COVID-19 cases in the United States from December 31st, 2019 to August 10th, 2020 in a month grouping. The table shows the total cases, deaths, and tests, in each month. The table also shows the average closing points of U.S market indices DOW JONES and S&P 500.

We can easily see which month had the most deaths, which also correlated to the lowest point on DOW JONES.

The table shows the slow beginning of the coronavirus has esclates exponentially within months. You can also see the market indices crash during the early onset of COVID-19, but recovering after DOW JONES reaches a low of 18591.93.

The table also shows how the number of tests being conducted each month is rapidly increasing, as the S&P 500 reaches near all time highs.

Year Month Total Cases Total Deaths DOW Average S&P Average New Tests Positive Rate Tests Per Case
2019 12 0 0 28538.44 3230.780 0 NaN NaN
2020 1 5 0 28879.99 3278.203 0 NaN NaN
2020 2 33 0 28519.73 3277.314 0 NaN NaN
2020 3 111892 2062 22637.42 2652.394 794554 0.1121667 10.246167
2020 4 577137 40705 23293.90 2761.975 3654576 0.1790952 5.785048
2020 5 450083 28282 24271.02 2919.608 6944778 0.0784500 13.739550
2020 6 569508 16744 26062.27 3104.661 11056518 0.0515455 19.691364
2020 7 1342556 18814 26385.83 3207.619 16370782 0.0811818 12.378227
2020 8 310049 6170 27217.72 3331.633 3603396 0.0804000 12.461600


Coronavirus by Counties in the United States

This chart shows total COVID-19 cases across the United States, in the beginning of August, 2020. The map shows hotspots across the country where COVID-19 is more rampant. The hotspots correspond to areas where the population density is much higher, while less dense areas have far less COVID-19 cases.


Coronavirus and United States Market Performance

This grid of charts demonstrates how the U.S markets had been impacted by the coronavirus. As you can see during the initial outbreak of coronavirus, the markets plunged more than 30% in a matter of weeks. Then you can see the market rapidly recovery and hitting all time highs in the S&P.


Mask Usage for Top Five Counties in the United States

This is a bar chart that demonstrates the frequency of mask usages for the top five populous county in the United States. Looking at this chart and comparing it to the cases in each state. You can see the correlation of mask usage and number of COVID-19 incidence.